Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
7 ?>
8 <?php
9 require_once('session1.php');
10 ?>
11 <?php
12 $id = $_GET['id'];
13 $select = "SELECT * FROM
14 studentstable WHERE admission_number='$id'";
15 $result = mysqli_fetch_array(mysqli_query($conn,$select));
16 $qry=mysqli_query($conn,$select);
17 if($qry)
18 {
19 while($rec = mysqli_fetch_array($qry)){
20 $sirname = "$rec[sirname]";
21 $firstname = "$rec[firstname]";
22 $lastname = "$rec[lastname]";
23 $gender = "$rec[gender]";
24 $mobile = "$rec[mobile]";
25 $email = "$rec[email]";
26 $address = "$rec[address]";
27 $zipcode = "$rec[zipcode]";
28 $course_id = "$rec[course_id]";
29 }}
30 ?>
31
32 <?php
33 SESSION_START();
34 ?>
35 <!DOCTYPE html>
36 <html>
37
38 <head>
39 <meta charset="utf-8">
40 <meta name="viewport" content="width=device-width, initial-scale=1.0">
41 <title>school management system</title>
42 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
43 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
44 <link href="assets/css/loader.css" rel="stylesheet" />
45 <script src="assets/js/canvasjs.min.js"></script>
46 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
47 <script src="assets/js/jquery-3.2.1.js"></script>
48
49 <script type="text/javascript">
50 function sum(){
51 var first_number = parseInt(document.getElementById("a").value);
52 var second_number = parseInt(document.getElementById("b").value);
53 var final =((first_number + second_number)/90)*100;
54 var result=Math.round(final);
55 document.getElementById("english").value = result;
56 }
57 </script>
58 <script type="text/javascript">
59 function sum2(){
60 var first_number = parseInt(document.getElementById("c").value);
61 var second_number = parseInt(document.getElementById("d").value);
62 var final =((first_number + second_number)/90)*100;
63 var result=Math.round(final);
64
65 document.getElementById("kiswahili").value = result;
66 }
67 </script>
68 <!--*****************calculating average marks*********************-->
69 <script type="text/javascript">
70 function final(){
71 var a = parseInt(document.getElementById("a").value);
72 var b = parseInt(document.getElementById("b").value);
73 var c = parseInt(document.getElementById("c").value);
74 var d = parseInt(document.getElementById("d").value);
75 var e = parseInt(document.getElementById("e").value);
76 var f = parseInt(document.getElementById("f").value);
77 var g = parseInt(document.getElementById("g").value);
78 var h = parseInt(document.getElementById("h").value);
79
80
81 //var number_of_subjects = parseInt(document.getElementById("h").value);
82
83 var final =((a + b + c + d + e + f+ g + h )/8);
84 var result=Math.round(final);
85
86 document.getElementById("average").value = result;
87 }
88 </script>
89
90
91
92 </head>
93
94 <body >
95 <!--end of heading section-->
96 <ul class="nav navbar-right top-nav">
97 <div class="dropdown">
98 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
99 <?php
100 //Check to see if the user is logged in.if not redirect user to the loging page.
101
102 if(isset($_SESSION['fname']))
103 {
104 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
105 }else{
106 echo "<script type='text/javascript'>
107 alert( 'You must Log in to use the system');
108 </script>";
109 echo "<script>
110 window.location = 'index.php'
111 </script>";
112 }
113 ?>
114 <span class="caret"></span></button>
115 <ul class="dropdown-menu">
116 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
117 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
118 <li class="divider"></li>
119 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
120 </ul>
121 </div>
122 </ul>
123 <!--************************************************-->
124 <div style="
125 font-family:Nyala, Arial;
126 text-align: left;
127 background-color: #526F35;
128 padding: 20px;
129 color:white;
130 width: 100%;
131 height: 150px;">
132 <!--This codes to load the image loader-->
133 <div id="loading">
134 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
135 </div>
136 <!--this is the heading section-->
137 <h2>
138 <?php
139 $sql="SELECT * FROM companyinfo";
140 $result=mysqli_query($db,$sql) or die("error getting data");
141 $num_rows=mysqli_num_rows($result);
142 while($row=mysqli_fetch_array($result))
143 {
144 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
145 $cname = $row['cname'];
146 $cemail = $row['cemail'];
147 $ccontact = $row['ccontact'];
148 $clocation = $row['clocation'];
149 }?>
150 <?php
151 echo $cname;
152 ?>
153
154 <div style="float:right; font-size:20px;text-align:right;">
155
156 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
157 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
158 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
159
160 </div>
161 </h2>
162 </div>
163 <!--end of heading section-->
164
165 <div>
166 <ul class="nav nav-tabs">
167 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
168 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
169 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
170 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
171 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
172 <li class="active"><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
173 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
174 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
175 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
176 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
177
178 </ul>
179 <div class="tab-content">
180 <div class="tab-pane active" role="tabpanel" id="tab-1">
181
182 <p>
183 <div class="table-responsive" >
184 <!--****************************************************************************-->
185 <div class="container" style="width:100%">
186
187 <ul class="nav nav-tabs">
188 <li ><a href="markstep1.php">Choose Class <img src="assets/img/new.png"> </a></li>
189
190 <li class="active"><a href="markstep3.php">Enter Marks<img src="assets/img/view2.png"></a></li>
191
192
193
194
195 <li><a href="markstep7.php">Print Transcript<img src="assets/img/print.png"> </a></li>
196 </ul>
197 <br>
198
199 </div>
200
201 <!--*************************************************************************************************************************-->
202 <div class="container-fluid">
203 <div class="row">
204 <div class="col-lg-6 col-lg-offset-3">
205 <div class="panel panel-primary">
206 <div class="panel-heading">Marks</div>
207 <!-- /.panel-heading -->
208 <div class="panel-body">
209 <div class="table">
210
211
212 <form action="marks_packages.php" method="POST" enctype="multipart/form-data">
213 <div style="float:left; position:relative">
214 <h4><font color="green">Marks Entry</font></h4>
215 <table>
216 <tr>
217 <td><label>Student ID</label></td>
218 <td><input type="text" name="admission_number" value="<?php echo $id?>" class="form-control"></td>
219 <td><label>Class</label></td>
220 <td><input type="text" name="course_id" value="<?php echo $course_id?>" class="form-control"></td>
221 <tr/>
222 <tr>
223 <td><label>Term</label></td>
224 <td><select class="form-control" name="term">
225 <?php
226 include('connect.php');
227 $sql1="SELECT * FROM term";
228 $records1=mysqli_query($db,$sql1);
229 while($row=mysqli_fetch_array($records1))
230 {
231 echo "<option>".$row['termname']."</option>";
232
233 }
234 ?></select></td>
235 <td><label>Year</label></td>
236 <?php
237 // set start and end year range
238 $yearArray = range(2016, 2050);
239 ?>
240 <!-- displaying the dropdown list -->
241 <td> <select name="year" class="form-control">
242 <?php
243 foreach ($yearArray as $year) {
244 // if you want to select a particular year
245 $selected = ($year == 2018) ? 'selected' : '';
246 echo '<option '.$selected.' value="'.$year.'">'.$year.'</option>';
247 }
248 ?> </select></td> </tr><tr>
249
250 <td> <label> Exam Series</label></td>
251 <td> <select name="exam_series" class="form-control">
252 <option>End Term</option>
253 </select></td> </tr></table>
254
255 </div>
256
257 <div style="float:left; position:relative">
258 <h4><font color="green">Subjects</font></h4>
259
260 <table><tr>
261 <td><label>INTRODCUTION TO COMPUTERS
262 <input type="number" name="introduction_to_computers" id="a" class="form-control" onkeyup="final()" max="100" >
263 </td>
264 <td><label>MS WINDOWS
265 <input type="number" name="ms_windows" id="b" class="form-control" onkeyup="final()" max="100" >
266 </td></tr>
267
268 <tr>
269 <td><label>MS WORD
270 <input type="number" name="ms_word" id="c" class="form-control" onkeyup="final()" max="100" >
271 </td>
272 <td><label>MS EXCEL
273 <input type="number" name="ms_excel" id="d" class="form-control" onkeyup="final()" max="100" >
274 </td></tr>
275
276 <tr>
277 <td><label>MS ACCESS
278 <input type="number" name="ms_access" id="e" class="form-control" onkeyup="final()" max="100" >
279 </td>
280 <td><label>MS POWERPOINT
281 <input type="number" name="ms_powerpoint" id="f" class="form-control" onkeyup="final()" max="100" >
282 </td></tr>
283
284 <tr>
285 <td><label>MS PUBLISHER
286 <input type="number" name="ms_publisher" id="g" class="form-control" onkeyup="final()" max="100" >
287 </td>
288 <td><label>INTERNET AND EMAIL
289 <input type="number" name="internet_and_email" id="h" class="form-control" onkeyup="final()" max="100" >
290 </td></tr>
291
292
293 </table>
294 <label>Average</label>
295 <input type="text" name="average" id="average" class="form-control" placeholder="Average" ><br>
296 <div style="float:right; position:relative; clear:both;">
297
298 <input type="submit" name="register" value="Save Entry" class="btn btn-success" >
299 </div>
300 </form>
301 </div>
302 </div>
303 </div>
304 </div>
305 </div>
306 <!--****************************************************************************-->
307 <?php
308 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
309 if (isset($_POST['register'])){
310
311
312 /*$xx=$_POST['course_idz'];
313 $sql="SELECT * FROM course WHERE coursename='$xx'";
314 $user_query=mysqli_query($db,$sql) or die("error getting data");
315 while($row = mysqli_fetch_array($user_query)){
316 $course_id = $row['course_id'];}*/
317
318 $admission_number=$_POST['admission_number'];
319 $course_id=$_POST['course_id'];
320 $term=$_POST['term'];
321 $year=$_POST['year'];
322 $exam_series=$_POST['exam_series'];
323 $introduction_to_computers=$_POST['introduction_to_computers'];
324 $ms_word=$_POST['ms_word'];
325 $ms_windows=$_POST['ms_windows'];
326 $ms_excel=$_POST['ms_excel'];
327 $ms_access=$_POST['ms_access'];
328 $ms_publisher=$_POST['ms_publisher'];
329 $ms_powerpoint=$_POST['ms_powerpoint'];
330 $internet_and_email=$_POST['internet_and_email'];
331 $average=$_POST['average'];
332
333 mysqli_query($conn,"INSERT INTO
334 packages_marks(
335 `admission_number`, `course_id`, `term`, `year`, `INTRODUCTION_TO_COMPUTERS`, `MS_WINDOWS`, `MS_EXCEL`, `MS_ACCESS`, `MS_PUBLISHER`, `MS_POWERPOINT`, `MS_WORD`, `INTERNET_AND_EMAIL`, `average` )
336 VALUES
337 ('$admission_number','$course_id','$term','$year','$introduction_to_computers','$ms_windows','$ms_excel','$ms_access','$ms_publisher','$ms_powerpoint','$ms_word','$internet_and_email','$average')") or die(mysqli_error());
338 ?>
339 <?php
340 $query="SELECT * FROM marks";
341 $records2=mysqli_query($db,$query);
342 while($rec=mysqli_fetch_array($records2))
343 {
344 $id = $rec['id'];
345 }?>
346
347 <script>
348
349 alert('Succsessfully Save.');
350 window.location = "markstep1.php?id=<?php echo $id;?>";
351 </script>
352 <?php }?>
353
354 <!--****************************************************************************-->
355
356
357 </div>
358 </p>
359
360
361 </div>
362
363 </div>
364 </div>
365
366 <div div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
367 <p class="text-center text-danger" style="color:white;">@J. Muthama Tel: +254729734768</p>
368 </div>
369 <script src="assets/js/jquery.min.js"></script>
370 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
371 <script src="assets/js/affix.js"></script>
372 <script src="assets/js/alert.js"></script>
373 <script src="assets/js/alert1.js"></script>
374 <script src="assets/js/bootstrap.js"></script>
375 <script src="assets/js/bootstrap.min.js"></script>
376 <script src="assets/js/bootstrap-datepicker.js"></script>
377 <script src="assets/js/bootstrap-wysihtml5.js"></script>
378 <script src="assets/js/button.js"></script>
379 <script src="assets/js/carousel.js"></script>
380 <script src="assets/js/chosen.jquery.min.js"></script>
381 <script src="assets/js/ckeditor.js"></script>
382 <script src="assets/js/collapse.js"></script>
383 <script src="assets/js/color.js"></script>
384 <script src="assets/js/dropdown.js"></script>
385 <script src="assets/js/DT_bootstrap.js"></script>
386 <script src="assets/js/dynamic.js"></script>
387 <script src="assets/js/ie-emulation-modes-warning.js"></script>
388 <script src="assets/js/jquery.dataTables.js"></script>
389 <script src="assets/js/jquery.dataTables.min.js"></script>
390 <script src="assets/js/jquery.dialog.js"></script>
391 <script src="assets/js/jquery.hoverdir.js"></script>
392 <script src="assets/js/jquery.jgrowl.js"></script>
393 <script src="assets/js/jquery.knob.js"></script>
394 <script src="assets/js/jquery.uniform.min.js"></script>
395 <script src="assets/js/jquery-1.8.3.min.js"></script>
396 <script src="assets/js/jquery-1.9.1.js"></script>
397 <script src="assets/js/jquery-1.9.1.min.js"></script>
398 <script src="assets/js/jquery-1.10.2.js"></script>
399 <script src="assets/js/jquery-1.11.0.js"></script>
400 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
401 <script src="assets/js/jquery-ui-1.10.3.js"></script>
402 <script src="assets/js/modal.js"></script>
403 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
404 <script src="assets/js/myjquery.js"></script>
405 <script src="assets/js/myjquery1.js"></script>
406 <script src="assets/js/npm.js"></script>
407 <script src="assets/js/popover.js"></script>
408 <script src="assets/js/profile.js"></script>
409 <script src="assets/js/raphael-min.js"></script>
410 <script src="assets/js/sb-admin-2.js"></script>
411 <script src="assets/js/scripts.js"></script>
412 <script src="assets/js/scrollspy.js"></script>
413 <script src="assets/js/tab.js"></script>
414 <script src="assets/js/tooltip.js"></script>
415 <script src="assets/js/transition.js"></script>
416 <script src="assets/js/wysihtml5-0.3.0.js"></script>
417 <script language="javascript" type="text/javascript">
418 $(window).load(function()
419 {
420 $('#loading').hide();
421 });
422 </script>
423 </body>
424
425 </html>